package com.industrial.loweff.mapper;

import com.industrial.loweff.domain.*;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface LowEffCompanyMapper {

    /**
     * 查询列表
     * @param params
     * @return
     */
    List<LowEfficiencyBenefitEvaluation> list(LowEfficiencyBenefitEvaluation params);

    /**
     * 通过ID查询亩产数据
     * @param id
     * @return
     */
    LowEfficiencyBenefitEvaluation selectPreMuBenefitEvaluationById(@Param("id") String id);

    List<LowEfficiencyBenefitEvaluation> selectPreMuBenefitEvaluationByMjLevel(@Param("mjLevel") String mjLevel);

    /**
     * 查询用地税收近一年数据
     * @param jcQueryParam
     */
    List<JcQueryDo> queryDwydssJyn(@Param("years") String years,@Param("params")JcQueryParam jcQueryParam);

    /**
     * 查询16地市
     * @return
     */
    List<LowArea> selectCityInfo(@Param("params") JcQueryParam jcQueryParam);

    /**
     * 查询用地税收近Charts
     * @param jcQueryParam
     */
    JcQueryDo queryDwydssJynCharts(@Param("years")String yiYear, @Param("params")JcQueryParam jcQueryParam);

    List<JcQueryDo> queryDwnhxssr(@Param("years") String years,@Param("params")JcQueryParam jcQueryParam);


    JcQueryDo queryDwnhxssrCharts(@Param("years") String years,@Param("params")JcQueryParam jcQueryParam);

    List<JcQueryDo> queryDwwrpfxssr(@Param("years") String years,@Param("params")JcQueryParam jcQueryParam);

    /**
     * 查询单位污染排放销售收入Charts
     *
     * @param jcQueryParam
     * @return
     */
    JcQueryDo queryDwwrpfxssrCharts(@Param("years") String years,@Param("params")JcQueryParam jcQueryParam);

    /**
     * 查询研发经费投入
     *
     * @param jcQueryParam
     * @return
     */
    List<JcQueryDo> queryYfjftr(@Param("years") String years,@Param("params")JcQueryParam jcQueryParam);

    /**
     * 查询研发经费投入Charts
     *
     * @param jcQueryParam
     * @return
     */
    JcQueryDo queryYfjftrCharts(@Param("years") String years,@Param("params")JcQueryParam jcQueryParam);

    /**
     * 查询全员劳动生产力
     *
     * @param jcQueryParam
     * @return
     */
    List<JcQueryDo> queryQyldscl(@Param("years") String years,@Param("params")JcQueryParam jcQueryParam);

    /**
     * 查询全员劳动生产力Charts
     *
     * @param jcQueryParam
     * @return
     */
    JcQueryDo queryQyldsclCharts(@Param("years") String years,@Param("params")JcQueryParam jcQueryParam);

    /**
     * 查询单位用地销售
     *
     * @param jcQueryParam
     * @return
     */
    List<JcQueryDo> queryDwysxssr(@Param("years") String years,@Param("params")JcQueryParam jcQueryParam);
    /**
     * 查询单位用地销售Charts
     *
     * @param jcQueryParam
     * @return
     */
    JcQueryDo queryDwysxssrCharts(@Param("years") String years,@Param("params")JcQueryParam jcQueryParam);

    /**
     * 查询低效能企业
     *
     * @param params
     * @return
     */
    List<JcResVo> queryLowerCompanyInfoByCd(@Param("params") LowEfficiencyBenefitEvaluation params);
}
